SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Located just outside the heart of Hanover, the home is perfect for those looking for privacy. The home features a functional layout designed to take advantage of its natural surroundings. Hardwood floors run throughout the main level, where a spacious living room with a pellet stove offers a cozy retreat during colder months. The main level is bright and sunny with a wrap-around deck off the main living space which provides an ideal spot for enjoying the warmer months. The lower level provides great overflow space and includes a gas fireplace, a laundry area, and a three quarter bath. A converted garage spaces now serves as a practical mudroom, storage area, or potential workshop. Outside, the property’s expansive front and back yards, offer ample space for outdoor activities, gardening, privacy, and relaxation. With its desirable location near hiking trails, schools, and cultural attractions, this home offers a quiet retreat without sacrificing proximity to Hanover’s vibrant downtown.
Description:Discover a rare gem in the heart of Lebanon—this expansive single level 4-bedroom, 4-bathroom home is nestled on 43 picturesque acres. Enjoy stunning westerly views, ample living space, and the perfect blend of privacy and convenience. This unique property offers the tranquility of country living with all the benefits of being close to town. With several acres of open pasture land and a barn/stable, the property would be well suited for horses or other grazing animals. The 10 KW solar array reduces current power demands with room for future expansion. Imagine snowshoeing, and cross-country skiing on your own land in the winter while enjoying the pollinator flowers and organic vegetable gardens by the half basketball court. The downstairs includes a library, bar, and a large space to create what you want. In addition, the property benefits from easy access to downtown Lebanon, Dartmouth College, Dartmouth-Hitchcock, I89 and I91, Lebanon Airport, and the Dartmouth Coach, which goes to New York or Boston. Don’t miss out on this exceptional opportunity located at the end of a dead-end road! Home is being sold as is. The property does need work to make it special again.
Description:Yankee Barn home privately situated on 7 acres in Olde Farms with 4 bedrooms and 4 baths. Look out over a sloping lot to the woods beyond from a spacious wrap-around deck. Marvel at the 3-story great room with a floor-to-ceiling brick fireplace, gleaming pine wood floors, and a window display all the way up to the cathedral ceiling. Natural woodwork and solid wood doors throughout give this home a warm and welcoming aesthetic. Entertain from the open, updated kitchen with quartz countertops, a breakfast bar and newer stainless steel appliances. Take your pick of two first-floor bedroom suites, both with Jacuzzi tubs and one with its own fireplace. The lower level walkout family room features a brick hearth, kitchenette, half bath and sun space with skylights. Great for indoor plants! On the 2nd floor, you'll find a loft area with built-ins, the 3rd and 4th bedrooms, and another full bath. If that’s not enough space, climb the traditional staircase to the 3rd floor to find yet another room with skylights that could be used for hobbies, a play room, an office, etc. Complete with a 1-car garage under and a 2-car detached garage. Other amenities include a Buderus heating system, Rinnai tankless water heater, newer standing seam roof, AC mini splits, 2 separate septic systems and an automatic standby whole-house generator. Come enjoy the rural setting and close community you’ll find in Grantham, NH. In the heart of the Dartmouth - Lake Sunapee Region, only 20 minutes from DHMC.
Description:Golf Course Home in Eastman situated on the 18th green! Conveniently located off a paved road at the end of a long driveway for privacy. Relish an easy walk across the path to The Center at Eastman and Forbes Tavern. What an advantage to be so near the clubhouse! Plus, you can walk right out your yard to groomed cross-country ski trails in the winter! This 3-bedroom, 2.5 bath home has been totally updated and meticulously maintained. Enter through the foyer to a light and bright great room with soaring cathedral ceilings, a floor-to-ceiling brick fireplace, built-ins and a wall of windows. Continue to the dining area and L-shaped kitchen beyond. This gourmet kitchen features an island with breakfast bar, stainless steel appliances, a walk-in pantry and ample cabinets and counter space. Enjoy the beauty of nature throughout the year from the four-season sunroom with mini split. In the warmer months, take advantage of a spacious wrap-around deck. The first-floor primary bedroom with ensuite bath and deck access, first-floor laundry, half-bath and a den/office with built-ins completes the main level. The upper level includes a loft area for additional seating, another bathroom, 2 more bedrooms and a bonus room that could be used for another sleeping area. Imagine the expansion possibilities available with the lower level walkout, which has been framed but not finished. Attached 2-car garage is a plus. Eastman also has lake activities, tennis, pickleball, an indoor pool and more.
Description:"The Rock Ridge Community" Offering 326 pristine acres of nature, trails, and riverfront access to all that the Upper Valley has to offer. The Upper Valley's Premier Neighborhood, all New Construction. This new home offers 4 bedroom, 3.5 bath home with extra living space above garage and unfinished full basement. Open concept living with hardwood floors, granite counter tops, tiled baths, flexible floor plan and many other upgrades. Share the community garden, enjoy socials at the Farmhouse and the privileges that HOA provides. Close to I-89, DHMC and Dartmouth College, Lebanon 6 Theater, Downtown, and plenty of shopping. Photos show current construction status completion date June 30, 2025.